-
Re: Smartsheet has been recognized as a Leader in the 2024 Gartner Magic Quadrant for Collaborative Work
I started using Smartsheet and then I… became designated as the project manager for our course design process. Smartsheet revolutionized our capacity to build courses and all of the automations compl…1 · -
Re: Populate a Date field when a status is changed
You can now set a date based on another cell change using automation and automation workflow!2 · -
Re: Remove #NO MATCH return from VLOOKUP query
You can wrap your formula in an IFERROR function. =IFERROR(Your formula, "") * https://help.smartsheet.com/function/iferror1 · -
Re: NEW! Forms minor updates and enhancements
Nice additions. Thanks!1 · -
Re: IF & ISBlank Function
Try this nested IF statement that checks for blank scores and keeps the field blank. I also updated your formula to work in any row. =IF(ISBLANK(Score@row), "", IF(Score@row < 80, "…1 ·